CREATE  PROCEDURE [dbo].[asi_InstitutesFromIndividual]
    @individualkey uniqueidentifier
AS
BEGIN
select vBoInstitute.ContactKey from vBoInstitute
    where vBoInstitute.InstituteGroupKey in
        (select    vBoGroup.GroupKey from vBoGroup inner join GroupMember
            on vBoGroup.GroupKey = GroupMember.GroupKey
            where GroupMember.MemberContactKey = @individualkey)
END

GO